ODBC with ADO and RDO

  1. Click the ODBC option in the Select Data Source dialog box.

    This option allows you to connect to an ODBC data source through ADO or RDO. The currently selected data objects technology appears in parentheses next to the ODBC option.

  1. After you select your data source and data objects technology, you can click Next in the Select Data Source dialog box.

    The Select Recordset dialog box appears.

  2. If the ODBC data source requires log on information, specify a user name and password to log on.
  3. Determine if you want to create a Recordset or Resultset using an object available from your data source, such as a database table, or if you prefer to specify a SQL statement. Select the appropriate option in the Recordset section of the Select Recordset dialog box.

    Note:    For simplicity, RDO Resultsets are also referred to as Recordsets in this dialog box.

  4. If you want to connect to a database object, use the Object Type drop-down list box to select the type of database object, such as a Table, then select the object itself from the Object drop-down list box.
  5. If you want to obtain a Recordset using a SQL statement, write the SQL statement in the text box provided, or click Build to use the Microsoft Query application and Query Wizard to visually design your SQL statement.
  6. Click Finish in the Select Recordset dialog box. Either ado or rdo will appear in the list box on the Data Tab of the Standard Report Expert.
  7. Continue creating your report normally. While creating your report, the ado or rdo specification will act like a database table, providing all fields that have been obtained from your ADO Recordset or RDO Resultset.


Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com